SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE table_name(
    column1 datatype,
    column2 datatype,
    column3 datatype,
    ....
);

SQLize.online - Popular functions

SELECT WHERE ORDER BY CREATE TABLE INSERT INTO JOIN GROUP BY PRIMARY KEY AND NOT LIKE COUNT SHOW FOREIGN KEY WITH CONSTRAINT LEFT AUTO_INCREMENT DROP TABLE INNER JOIN IN SUM DEFAULT LENGTH HAVING UPDATE OR BETWEEN DELETE ALTER TABLE CONCAT CASE CREATE VIEW DROP VIEW MONTH ROW_NUMBER CREATE PROCEDURE EXEC REPLACE DROP PROCEDURE RIGHT ADD CONSTRAINT LEAD DENSE_RANK LAG COALESCE SUBSTRING CROSS JOIN OUTER JOIN CREATE FUNCTION CREATE OR REPLACE FUNCTION INSERT INTO TRUNCATE ADD COLUMN UPPER LOWER DROP COLUMN SUBSTR TRIM DAYOFWEEK DESCRIBE INSERT INTO CREATE OR REPLACE VIEW IFNULL CREATE OR REPLACE PROCEDURE LEFT JOIN REVERSE JSON_ARRAY JSON_CONTAINS DROP CONSTRAINT INSERT INTO LPAD INSERT INTO UUID_GENERATE_V4 ORDER BY INNER JOIN NULLIF JSON_AGG ADD CONSTRAINT INSERT INTO CREATE OR REPLACE TRIGGER GROUP BY DROP FUNCTION RTRIM RPAD LTRIM PRIMARY KEY DROP INDEX ROW_TO_JSON DROP TRIGGER FOREIGN KEY DROP SEQUENCE DROP PROCEDURE CREATE TABLE ADD COLUMN ADD CONSTRAINT CREATE OR REPLACE FUNCTION DROP TABLE INSERT INTO INNER JOIN